Mysql安全启动配置向导

您所在的位置:网站首页 mysql安装server file permissions Mysql安全启动配置向导

Mysql安全启动配置向导

2024-05-01 08:49| 来源: 网络整理| 查看: 265

安装完mysql-server 会提示可以运行mysql_secure_installation。运行mysql_secure_installation会执行以下几个设置:

- 为root用户设置密码

- 删除匿名账号

- 取消root用户远程登录

- 删除test库和对test库的访问权限

- 刷新授权表使修改生效

 通过以上几项设置能够提高mysql库的安全。建议生产环境中mysql安装这完成后一定要运行一次mysql_secure_installation,相关操作如下:

代码语言:javascript复制[root@localhost ~]# mysql_secure_installation NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY! In order to log into MySQL to secure it, we'll need the current password for the root user. If you've just installed MySQL, and you haven't set the root password yet, the password will be blank, so you should just press enter here. Enter current password for root (enter for none):


【本文地址】


今日新闻


推荐新闻


CopyRight 2018-2019 办公设备维修网 版权所有 豫ICP备15022753号-3